Express版本通过windows定时任务备份

编写脚本sqlserver.sql

DECLARE @backupTime VARCHAR(20)
DECLARE @fileName VARCHAR(1000)
SELECT @backupTime = (CONVERT(VARCHAR(8), GETDATE(), 112) +REPLACE(CONVERT(VARCHAR(5), GETDATE(), 114), ':', ''))
SELECT @fileName='C:\BuckUp\DBName_'+@backupTime+'.bak'
backup database DBName to disk=@fileName

编写脚本backup.bat

sqlcmd -S "." -E -d "DBName" -i "C:\BuckUp\sqlserver.sql"

将backup.bat添加到任务计划程序-创建基本任务

注：sql脚本示例

sqlcmd -S "127.0.0.1" -U "sa" -P "sa" -d "MyDB" -i "D:\test.sql" --SQL登录
sqlcmd -S "127.0.0.1" -E -d "MyDB" -i "D:\test.sql" --Windows身份登录